create  view vPledgeBalances as
    select i.BT_ID,
           SUM(i.BALANCE) as BALANCE
    from Invoice i
    where i.SOURCE_SYSTEM = 'FR' and i.BALANCE <> 0
group by i.BT_ID

GO
GRANT REFERENCES ON  [dbo].[vPledgeBalances] TO [IMIS]
GRANT SELECT ON  [dbo].[vPledgeBalances] TO [IMIS]
GRANT INSERT ON  [dbo].[vPledgeBalances] TO [IMIS]
GRANT DELETE ON  [dbo].[vPledgeBalances] TO [IMIS]
GRANT UPDATE ON  [dbo].[vPledgeBalances] TO [IMIS]
GO